/*
 Navicat Premium Data Transfer

 Source Server Type    : MySQL
 Source Server Version : 80015
 Source Database       : ordersys_db

 Target Server Type    : MySQL
 Target Server Version : 80015
 File Encoding         : utf-8

 Date: 05/18/2019 18:17:48 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `t_dict`
-- ----------------------------
DROP TABLE IF EXISTS `t_dict`;
CREATE TABLE `t_dict` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `dict_value` varchar(32) DEFAULT NULL,
  `dict_name` varchar(32) DEFAULT NULL,
  `dict_remark` varchar(255) DEFAULT NULL,
  `dict_type` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
--  Records of `t_dict`
-- ----------------------------
BEGIN;
INSERT INTO `t_dict` VALUES ('1', '0', '业务员', null, 'person'), ('2', '1', '仓管', null, 'person'), ('3', '2', '财务', null, 'person'), ('4', '3', '生产', null, 'person'), ('5', '4', '管理', null, 'person'), ('6', '-1', '订单已删除', null, 'order'), ('7', '0', '下单成功', null, 'order'), ('8', '1', '已开始生产', null, 'order'), ('9', '2', '生产完成待审批', null, 'order'), ('10', '3', '已批准,待发货', null, 'order'), ('11', '4', '已发货', null, 'order'), ('12', '5', '已到货', null, 'order'), ('13', '6', '暂停发货', null, 'order'), ('14', '7', '重审通过批准发货', null, 'order');
COMMIT;

-- ----------------------------
--  Table structure for `t_goods`
-- ----------------------------
DROP TABLE IF EXISTS `t_goods`;
CREATE TABLE `t_goods` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `goods_name` varchar(32) DEFAULT NULL,
  `goods_quantity` varchar(32) DEFAULT NULL,
  `order_id` bigint(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
--  Table structure for `t_order`
-- ----------------------------
DROP TABLE IF EXISTS `t_order`;
CREATE TABLE `t_order` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `order_no` varchar(32) DEFAULT NULL,
  `order_time` varchar(32) DEFAULT NULL,
  `order_send_time` varchar(32) DEFAULT NULL,
  `order_receive_time` varchar(32) DEFAULT NULL,
  `customer_name` varchar(32) DEFAULT NULL,
  `customer_phone` varchar(32) DEFAULT NULL,
  `customer_address` varchar(32) DEFAULT NULL,
  `order_address` varchar(32) DEFAULT NULL,
  `person_id` bigint(11) DEFAULT NULL,
  `order_desc` varchar(100) DEFAULT NULL,
  `order_status` varchar(32) DEFAULT NULL,
  `delete_flag` tinyint(2) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


-- ----------------------------
--  Table structure for `t_order_yilianyun_token`
-- ----------------------------
DROP TABLE IF EXISTS `t_order_yilianyun_token`;
CREATE TABLE `t_order_yilianyun_token` (
  `access_token` varchar(200) DEFAULT NULL,
  `refresh_token` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


-- ----------------------------
--  Table structure for `t_person`
-- ----------------------------
DROP TABLE IF EXISTS `t_person`;
CREATE TABLE `t_person` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `open_id` varchar(32) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `phone` varchar(32) DEFAULT NULL,
  `person_type` varchar(32) DEFAULT NULL,
  `bind_status` tinyint(2) DEFAULT NULL,
  `enable_status` tinyint(2) DEFAULT NULL,
  `delete_flag` tinyint(2) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
--  Records of `t_person`
-- ----------------------------
BEGIN;
INSERT INTO `t_person` VALUES ('1', '', '田文瑞', '13758146946', '4', '0', '0', '0'), ('2', null, '陈景贤', '13116826536', '0', '0', '0', '0'), ('3', null, '朱天生', '13336093139', '0', '0', '0', '0'), ('4', null, '朱强', '13588811087', '0', '0', '0', '0'), ('5', null, '郑建明', '13295817888', '0', '0', '0', '0'), ('6', null, '杨华斌', '13119689550', '0', '0', '0', '0'), ('7', null, '田清辉', '15268705454', '1', '0', '0', '0'), ('8', null, '田庆森', '13851622188', '0', '0', '0', '0'), ('9', null, '汤苑兴', '13318299001', '0', '0', '0', '0'), ('10', null, '黄汉强', '18760638299', '0', '0', '0', '0'), ('11', null, '陈永忠', '13205051765', '0', '0', '0', '0'), ('12', null, '吴发展', '15068383176', '0', '0', '0', '0'), ('13', null, '林枫', '13850216333', '0', '0', '0', '0'), ('14', null, '戴鸿凌', '13567116533', '0', '0', '0', '0'), ('15', null, '欧阳小林', '18179260197', '0', '0', '0', '0'), ('16', null, '王雪斌', '15857296324', '0', '0', '0', '0'), ('17', null, '张熙洪', '18857285228', '0', '0', '0', '0'), ('18', null, '石萍', '13850262358', '3', '0', '0', '0'), ('19', null, '田夏清', '13336113871', '4', '0', '0', '0'), ('20', null, '唐晨曦', '18605940627', '0', '0', '0', '0'), ('21', null, '陈新红', '18357259961', '1', '0', '0', '0'), ('22', null, '田清平', '13732360839', '1', '0', '0', '0'), ('23', null, '唐建忠', '13175211310', '1', '0', '0', '0'), ('24', null, '毛志彤', '13857121856', '2', '0', '0', '0'), ('25', null, '唐丽贞', '13588366691', '2', '0', '0', '0'), ('26', null, '田清林', '13732360839', '3', '0', '0', '0'), ('27', null, '田清远', '15268706233', '3', '0', '0', '0'), ('28', null, '田清贵', '13059910635', '3', '0', '0', '0'), ('29', null, '田清高', '15268702199', '3', '0', '0', '0');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;